package com.lock.immersive.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lock.immersive.pojo.domain.Product;
import com.lock.immersive.pojo.domain.Tuan;
import com.lock.immersive.pojo.dto.SearchProductDto;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author zhao
* @description 针对表【product】的数据库操作Mapper
* @createDate 2023-07-02 00:04:03
* @Entity .domain.Product
*/
@Mapper
public interface ProductMapper extends BaseMapper<Product> {
    @Select("select * from tuan where product_id = #{productId} and tuan_process <> 'NOTSTART' and tuan_process <> 'END'")
    Tuan getTuanByProductId (@Param("productId") int productId);
    List<Product> selectProductByCondition(SearchProductDto product);
}




